Pandas Profiling Report

Dataset statistics

Number of variables	18
Number of observations	218160
Missing cells	2145379
Missing cells (%)	54.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	30.0 MiB
Average record size in memory	144.0 B

Variable types

Categorical	3
Numeric	15

Warnings

`dep` has a high cardinality: 101 distinct values	High cardinality
`date_de_passage` has a high cardinality: 360 distinct values	High cardinality
`nbre_pass_corona` is highly correlated with `nbre_pass_corona_h` and 1 other fields	High correlation
`nbre_pass_tot` is highly correlated with `nbre_pass_tot_h` and 1 other fields	High correlation
`nbre_hospit_corona` is highly correlated with `nbre_hospit_corona_h` and 1 other fields	High correlation
`nbre_pass_corona_h` is highly correlated with `nbre_pass_corona` and 2 other fields	High correlation
`nbre_pass_corona_f` is highly correlated with `nbre_pass_corona` and 1 other fields	High correlation
`nbre_pass_tot_h` is highly correlated with `nbre_pass_tot` and 1 other fields	High correlation
`nbre_pass_tot_f` is highly correlated with `nbre_pass_tot` and 1 other fields	High correlation
`nbre_hospit_corona_h` is highly correlated with `nbre_hospit_corona` and 1 other fields	High correlation
`nbre_hospit_corona_f` is highly correlated with `nbre_hospit_corona`	High correlation
`nbre_acte_corona` is highly correlated with `nbre_acte_corona_h` and 1 other fields	High correlation
`nbre_acte_tot` is highly correlated with `nbre_acte_tot_h` and 1 other fields	High correlation
`nbre_acte_corona_h` is highly correlated with `nbre_acte_corona` and 1 other fields	High correlation
`nbre_acte_corona_f` is highly correlated with `nbre_acte_corona` and 1 other fields	High correlation
`nbre_acte_tot_h` is highly correlated with `nbre_acte_tot` and 1 other fields	High correlation
`nbre_acte_tot_f` is highly correlated with `nbre_acte_tot` and 1 other fields	High correlation
`nbre_pass_corona` has 2487 (1.1%) missing values	Missing
`nbre_pass_tot` has 2487 (1.1%) missing values	Missing
`nbre_hospit_corona` has 2487 (1.1%) missing values	Missing
`nbre_pass_corona_h` has 182165 (83.5%) missing values	Missing
`nbre_pass_corona_f` has 182165 (83.5%) missing values	Missing
`nbre_pass_tot_h` has 182165 (83.5%) missing values	Missing
`nbre_pass_tot_f` has 182165 (83.5%) missing values	Missing
`nbre_hospit_corona_h` has 182165 (83.5%) missing values	Missing
`nbre_hospit_corona_f` has 182165 (83.5%) missing values	Missing
`nbre_acte_corona` has 119258 (54.7%) missing values	Missing
`nbre_acte_tot` has 119258 (54.7%) missing values	Missing
`nbre_acte_corona_h` has 201603 (92.4%) missing values	Missing
`nbre_acte_corona_f` has 201603 (92.4%) missing values	Missing
`nbre_acte_tot_h` has 201603 (92.4%) missing values	Missing
`nbre_acte_tot_f` has 201603 (92.4%) missing values	Missing
`dep` is uniformly distributed	Uniform
`date_de_passage` is uniformly distributed	Uniform
`sursaud_cl_age_corona` is uniformly distributed	Uniform
`nbre_pass_corona` has 102432 (47.0%) zeros	Zeros
`nbre_hospit_corona` has 134855 (61.8%) zeros	Zeros
`nbre_pass_corona_h` has 10619 (4.9%) zeros	Zeros
`nbre_pass_corona_f` has 10785 (4.9%) zeros	Zeros
`nbre_hospit_corona_h` has 15585 (7.1%) zeros	Zeros
`nbre_hospit_corona_f` has 16943 (7.8%) zeros	Zeros
`nbre_acte_corona` has 41397 (19.0%) zeros	Zeros
`nbre_acte_corona_h` has 3358 (1.5%) zeros	Zeros
`nbre_acte_corona_f` has 2825 (1.3%) zeros	Zeros

Reproduction

Analysis started	2021-02-18 21:46:48.429572
Analysis finished	2021-02-18 21:47:20.497286
Duration	32.07 seconds
Software version	pandas-profiling v2.10.0
Download configuration	config.yaml

dep
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	101
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.7 MiB

26	2160
73	2160
974	2160
49	2160
89	2160
Other values (96)	207360

Length

Max length	3
Median length	2
Mean length	2.04950495
Min length	2

Characters and Unicode

Total characters	447120
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	01
2nd row	01
3rd row	01
4th row	01
5th row	01

Value	Count	Frequency (%)
26	2160	1.0%
73	2160	1.0%
974	2160	1.0%
49	2160	1.0%
89	2160	1.0%
76	2160	1.0%
90	2160	1.0%
79	2160	1.0%
94	2160	1.0%
13	2160	1.0%
Other values (91)	196560	90.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
26	2160	1.0%
73	2160	1.0%
49	2160	1.0%
89	2160	1.0%
76	2160	1.0%
90	2160	1.0%
79	2160	1.0%
94	2160	1.0%
13	2160	1.0%
12	2160	1.0%
Other values (91)	196560	90.1%

Most occurring characters

Value	Count	Frequency (%)
7	51840	11.6%
2	47520	10.6%
1	45360	10.1%
3	45360	10.1%
4	45360	10.1%
5	43200	9.7%
6	43200	9.7%
9	43200	9.7%
8	41040	9.2%
0	36720	8.2%
Other values (2)	4320	1.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	442800	99.0%
Uppercase Letter	4320	1.0%

Most frequent character per category

Value	Count	Frequency (%)
7	51840	11.7%
2	47520	10.7%
1	45360	10.2%
3	45360	10.2%
4	45360	10.2%
5	43200	9.8%
6	43200	9.8%
9	43200	9.8%
8	41040	9.3%
0	36720	8.3%

Value	Count	Frequency (%)
A	2160	50.0%
B	2160	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	442800	99.0%
Latin	4320	1.0%

Most frequent character per script

Value	Count	Frequency (%)
7	51840	11.7%
2	47520	10.7%
1	45360	10.2%
3	45360	10.2%
4	45360	10.2%
5	43200	9.8%
6	43200	9.8%
9	43200	9.8%
8	41040	9.3%
0	36720	8.3%

Value	Count	Frequency (%)
A	2160	50.0%
B	2160	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	447120	100.0%

Most frequent character per block

Value	Count	Frequency (%)
7	51840	11.6%
2	47520	10.6%
1	45360	10.1%
3	45360	10.1%
4	45360	10.1%
5	43200	9.7%
6	43200	9.7%
9	43200	9.7%
8	41040	9.2%
0	36720	8.2%
Other values (2)	4320	1.0%

date_de_passage
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	360
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	1.7 MiB

2020-08-31	606
2020-09-28	606
2020-05-13	606
2020-05-15	606
2021-01-15	606
Other values (355)	215130

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	2181600
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2020-02-24
2nd row	2020-02-24
3rd row	2020-02-24
4th row	2020-02-24
5th row	2020-02-24

Value	Count	Frequency (%)
2020-08-31	606	0.3%
2020-09-28	606	0.3%
2020-05-13	606	0.3%
2020-05-15	606	0.3%
2021-01-15	606	0.3%
2020-11-17	606	0.3%
2020-05-30	606	0.3%
2020-08-24	606	0.3%
2020-07-30	606	0.3%
2020-04-17	606	0.3%
Other values (350)	212100	97.2%

Histogram of lengths of the category

Value	Count	Frequency (%)
2020-08-31	606	0.3%
2020-09-28	606	0.3%
2020-05-13	606	0.3%
2020-05-15	606	0.3%
2021-01-15	606	0.3%
2020-11-17	606	0.3%
2020-05-30	606	0.3%
2020-08-24	606	0.3%
2020-07-30	606	0.3%
2020-04-17	606	0.3%
Other values (350)	212100	97.2%

Most occurring characters

Value	Count	Frequency (%)
0	674478	30.9%
2	560550	25.7%
-	436320	20.0%
1	218766	10.0%
3	50904	2.3%
5	40602	1.9%
7	40602	1.9%
4	39996	1.8%
6	39996	1.8%
8	39996	1.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1745280	80.0%
Dash Punctuation	436320	20.0%

Most frequent character per category

Value	Count	Frequency (%)
0	674478	38.6%
2	560550	32.1%
1	218766	12.5%
3	50904	2.9%
5	40602	2.3%
7	40602	2.3%
4	39996	2.3%
6	39996	2.3%
8	39996	2.3%
9	39390	2.3%

Value	Count	Frequency (%)
-	436320	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2181600	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	674478	30.9%
2	560550	25.7%
-	436320	20.0%
1	218766	10.0%
3	50904	2.3%
5	40602	1.9%
7	40602	1.9%
4	39996	1.8%
6	39996	1.8%
8	39996	1.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2181600	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	674478	30.9%
2	560550	25.7%
-	436320	20.0%
1	218766	10.0%
3	50904	2.3%
5	40602	1.9%
7	40602	1.9%
4	39996	1.8%
6	39996	1.8%
8	39996	1.8%

sursaud_cl_age_corona
Categorical

UNIFORM

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.7 MiB

B	36360
A	36360
C	36360
D	36360
0	36360

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	218160
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	A
3rd row	B
4th row	C
5th row	D

Value	Count	Frequency (%)
B	36360	16.7%
A	36360	16.7%
C	36360	16.7%
D	36360	16.7%
0	36360	16.7%
E	36360	16.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
a	36360	16.7%
b	36360	16.7%
d	36360	16.7%
e	36360	16.7%
0	36360	16.7%
c	36360	16.7%

Most occurring characters

Value	Count	Frequency (%)
0	36360	16.7%
A	36360	16.7%
B	36360	16.7%
C	36360	16.7%
D	36360	16.7%
E	36360	16.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	181800	83.3%
Decimal Number	36360	16.7%

Most frequent character per category

Value	Count	Frequency (%)
A	36360	20.0%
B	36360	20.0%
C	36360	20.0%
D	36360	20.0%
E	36360	20.0%

Value	Count	Frequency (%)
0	36360	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	181800	83.3%
Common	36360	16.7%

Most frequent character per script

Value	Count	Frequency (%)
A	36360	20.0%
B	36360	20.0%
C	36360	20.0%
D	36360	20.0%
E	36360	20.0%

Value	Count	Frequency (%)
0	36360	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	218160	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	36360	16.7%
A	36360	16.7%
B	36360	16.7%
C	36360	16.7%
D	36360	16.7%
E	36360	16.7%

nbre_pass_corona
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct	251
Distinct (%)	0.1%
Missing	2487
Missing (%)	1.1%
Infinite	0
Infinite (%)	0.0%

Mean	3.399493678
Minimum	0
Maximum	635
Zeros	102432
Zeros (%)	47.0%
Memory size	1.7 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	3
95-th percentile	15
Maximum	635
Range	635
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	10.55413546
Coefficient of variation (CV)	3.104619823
Kurtosis	438.964732
Mean	3.399493678
Median Absolute Deviation (MAD)	1
Skewness	14.77292928
Sum	733179
Variance	111.3897753
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	102432	47.0%
1	34299	15.7%
2	19187	8.8%
3	12325	5.6%
4	8490	3.9%
5	6346	2.9%
6	4721	2.2%
7	3854	1.8%
8	3120	1.4%
9	2486	1.1%
Other values (241)	18413	8.4%
(Missing)	2487	1.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	102432	47.0%
1	34299	15.7%
2	19187	8.8%
3	12325	5.6%
4	8490	3.9%

Value	Count	Frequency (%)
635	1	< 0.1%
549	1	< 0.1%
537	1	< 0.1%
536	1	< 0.1%
525	1	< 0.1%

nbre_pass_tot
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	1621
Distinct (%)	0.8%
Missing	2487
Missing (%)	1.1%
Infinite	0
Infinite (%)	0.0%

Mean	117.207082
Minimum	0
Maximum	2240
Zeros	3
Zeros (%)	< 0.1%
Memory size	1.7 MiB

Quantile statistics

Minimum	0
5-th percentile	10
Q1	29
median	59
Q3	127
95-th percentile	427
Maximum	2240
Range	2240
Interquartile range (IQR)	98

Descriptive statistics

Standard deviation	172.2271692
Coefficient of variation (CV)	1.469426303
Kurtosis	20.63477179
Mean	117.207082
Median Absolute Deviation (MAD)	37
Skewness	3.859724206
Sum	25278403
Variance	29662.1978
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17	2470	1.1%
20	2436	1.1%
19	2427	1.1%
18	2424	1.1%
24	2402	1.1%
23	2374	1.1%
22	2337	1.1%
28	2312	1.1%
26	2294	1.1%
16	2294	1.1%
Other values (1611)	191903	88.0%
(Missing)	2487	1.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3	< 0.1%
1	553	0.3%
2	718	0.3%
3	928	0.4%
4	968	0.4%

Value	Count	Frequency (%)
2240	1	< 0.1%
2227	1	< 0.1%
2188	1	< 0.1%
2102	1	< 0.1%
2090	1	< 0.1%

nbre_hospit_corona
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct	118
Distinct (%)	0.1%
Missing	2487
Missing (%)	1.1%
Infinite	0
Infinite (%)	0.0%

Mean	1.521252081
Minimum	0
Maximum	203
Zeros	134855
Zeros (%)	61.8%
Memory size	1.7 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	7
Maximum	203
Range	203
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	4.447144177
Coefficient of variation (CV)	2.92334468
Kurtosis	179.0656161
Mean	1.521252081
Median Absolute Deviation (MAD)	0
Skewness	9.607671325
Sum	328093
Variance	19.77709133
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	134855	61.8%
1	31870	14.6%
2	15090	6.9%
3	8800	4.0%
4	5889	2.7%
5	3888	1.8%
6	2838	1.3%
7	2136	1.0%
8	1631	0.7%
9	1311	0.6%
Other values (108)	7365	3.4%
(Missing)	2487	1.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	134855	61.8%
1	31870	14.6%
2	15090	6.9%
3	8800	4.0%
4	5889	2.7%

Value	Count	Frequency (%)
203	1	< 0.1%
193	1	< 0.1%
168	1	< 0.1%
157	1	< 0.1%
150	1	< 0.1%

nbre_pass_corona_h
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct	144
Distinct (%)	0.4%
Missing	182165
Missing (%)	83.5%
Infinite	0
Infinite (%)	0.0%

Mean	4.947770524
Minimum	0
Maximum	320
Zeros	10619
Zeros (%)	4.9%
Memory size	1.7 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	2
Q3	5
95-th percentile	19
Maximum	320
Range	320
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	10.51199952
Coefficient of variation (CV)	2.124593182
Kurtosis	132.1073272
Mean	4.947770524
Median Absolute Deviation (MAD)	2
Skewness	8.53524319
Sum	178095
Variance	110.5021339
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	10619	4.9%
1	5642	2.6%
2	3967	1.8%
3	2884	1.3%
4	2181	1.0%
5	1704	0.8%
6	1361	0.6%
7	1050	0.5%
8	811	0.4%
9	779	0.4%
Other values (134)	4997	2.3%
(Missing)	182165	83.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	10619	4.9%
1	5642	2.6%
2	3967	1.8%
3	2884	1.3%
4	2181	1.0%

Value	Count	Frequency (%)
320	1	< 0.1%
280	1	< 0.1%
254	1	< 0.1%
244	1	< 0.1%
240	2	< 0.1%

nbre_pass_corona_f
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct	152
Distinct (%)	0.4%
Missing	182165
Missing (%)	83.5%
Infinite	0
Infinite (%)	0.0%

Mean	5.235616058
Minimum	0
Maximum	315
Zeros	10785
Zeros (%)	4.9%
Memory size	1.7 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	2
Q3	6
95-th percentile	20
Maximum	315
Range	315
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	11.1820205
Coefficient of variation (CV)	2.135760219
Kurtosis	133.1954742
Mean	5.235616058
Median Absolute Deviation (MAD)	2
Skewness	8.502372967
Sum	188456
Variance	125.0375824
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	10785	4.9%
1	5596	2.6%
2	3738	1.7%
3	2758	1.3%
4	2026	0.9%
5	1726	0.8%
6	1338	0.6%
7	1039	0.5%
8	867	0.4%
9	717	0.3%
Other values (142)	5405	2.5%
(Missing)	182165	83.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	10785	4.9%
1	5596	2.6%
2	3738	1.7%
3	2758	1.3%
4	2026	0.9%

Value	Count	Frequency (%)
315	1	< 0.1%
292	1	< 0.1%
285	1	< 0.1%
283	1	< 0.1%
269	1	< 0.1%

nbre_pass_tot_h
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	924
Distinct (%)	2.6%
Missing	182165
Missing (%)	83.5%
Infinite	0
Infinite (%)	0.0%

Mean	182.241728
Minimum	0
Maximum	1176
Zeros	2
Zeros (%)	< 0.1%
Memory size	1.7 MiB

Quantile statistics

Minimum	0
5-th percentile	35
Q1	77
median	134
Q3	234
95-th percentile	486
Maximum	1176
Range	1176
Interquartile range (IQR)	157

Descriptive statistics

Standard deviation	151.9718787
Coefficient of variation (CV)	0.8339027527
Kurtosis	4.17304466
Mean	182.241728
Median Absolute Deviation (MAD)	68
Skewness	1.83307799
Sum	6559791
Variance	23095.4519
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
66	219	0.1%
68	211	0.1%
67	203	0.1%
77	201	0.1%
69	200	0.1%
73	199	0.1%
70	198	0.1%
61	198	0.1%
57	198	0.1%
71	197	0.1%
Other values (914)	33971	15.6%
(Missing)	182165	83.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	< 0.1%
1	14	< 0.1%
2	16	< 0.1%
3	12	< 0.1%
4	17	< 0.1%

Value	Count	Frequency (%)
1176	1	< 0.1%
1156	1	< 0.1%
1139	1	< 0.1%
1119	1	< 0.1%
1078	1	< 0.1%

nbre_pass_tot_f
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	867
Distinct (%)	2.4%
Missing	182165
Missing (%)	83.5%
Infinite	0
Infinite (%)	0.0%

Mean	168.8579247
Minimum	0
Maximum	1084
Zeros	9
Zeros (%)	< 0.1%
Memory size	1.7 MiB

Quantile statistics

Minimum	0
5-th percentile	32
Q1	73
median	125
Q3	217
95-th percentile	450
Maximum	1084
Range	1084
Interquartile range (IQR)	144

Descriptive statistics

Standard deviation	139.4479773
Coefficient of variation (CV)	0.8258302214
Kurtosis	4.153146514
Mean	168.8579247
Median Absolute Deviation (MAD)	63
Skewness	1.804841512
Sum	6078041
Variance	19445.73838
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
73	250	0.1%
96	218	0.1%
78	217	0.1%
48	214	0.1%
71	211	0.1%
87	211	0.1%
70	211	0.1%
84	210	0.1%
81	210	0.1%
89	208	0.1%
Other values (857)	33835	15.5%
(Missing)	182165	83.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	9	< 0.1%
1	18	< 0.1%
2	17	< 0.1%
3	13	< 0.1%
4	18	< 0.1%

Value	Count	Frequency (%)
1084	1	< 0.1%
1051	1	< 0.1%
1049	1	< 0.1%
1046	1	< 0.1%
1045	1	< 0.1%

nbre_hospit_corona_h
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct	83
Distinct (%)	0.2%
Missing	182165
Missing (%)	83.5%
Infinite	0
Infinite (%)	0.0%

Mean	2.506431449
Minimum	0
Maximum	130
Zeros	15585
Zeros (%)	7.1%
Memory size	1.7 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	3
95-th percentile	10
Maximum	130
Range	130
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	5.159971503
Coefficient of variation (CV)	2.058692451
Kurtosis	73.25180808
Mean	2.506431449
Median Absolute Deviation (MAD)	1
Skewness	6.288173487
Sum	90219
Variance	26.62530592
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	15585	7.1%
1	6660	3.1%
2	3849	1.8%
3	2479	1.1%
4	1596	0.7%
5	1208	0.6%
6	887	0.4%
7	661	0.3%
8	537	0.2%
9	421	0.2%
Other values (73)	2112	1.0%
(Missing)	182165	83.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	15585	7.1%
1	6660	3.1%
2	3849	1.8%
3	2479	1.1%
4	1596	0.7%

Value	Count	Frequency (%)
130	1	< 0.1%
127	1	< 0.1%
111	1	< 0.1%
102	1	< 0.1%
96	1	< 0.1%

nbre_hospit_corona_f
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct	60
Distinct (%)	0.2%
Missing	182165
Missing (%)	83.5%
Infinite	0
Infinite (%)	0.0%

Mean	2.05075705
Minimum	0
Maximum	76
Zeros	16943
Zeros (%)	7.8%
Memory size	1.7 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	9
Maximum	76
Range	76
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	3.999410507
Coefficient of variation (CV)	1.950211756
Kurtosis	37.78013143
Mean	2.05075705
Median Absolute Deviation (MAD)	1
Skewness	4.801567812
Sum	73817
Variance	15.9952844
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	16943	7.8%
1	6574	3.0%
2	3699	1.7%
3	2431	1.1%
4	1561	0.7%
5	1128	0.5%
6	785	0.4%
7	551	0.3%
8	424	0.2%
9	336	0.2%
Other values (50)	1563	0.7%
(Missing)	182165	83.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	16943	7.8%
1	6574	3.0%
2	3699	1.7%
3	2431	1.1%
4	1561	0.7%

Value	Count	Frequency (%)
76	1	< 0.1%
67	1	< 0.1%
65	1	< 0.1%
63	1	< 0.1%
59	1	< 0.1%

nbre_acte_corona
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct	156
Distinct (%)	0.2%
Missing	119258
Missing (%)	54.7%
Infinite	0
Infinite (%)	0.0%

Mean	3.657691452
Minimum	0
Maximum	259
Zeros	41397
Zeros (%)	19.0%
Memory size	1.7 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	4
95-th percentile	16
Maximum	259
Range	259
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	8.527124053
Coefficient of variation (CV)	2.331285775
Kurtosis	106.162822
Mean	3.657691452
Median Absolute Deviation (MAD)	1
Skewness	7.519453693
Sum	361753
Variance	72.71184461
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	41397	19.0%
1	16800	7.7%
2	9333	4.3%
3	6009	2.8%
4	4340	2.0%
5	3257	1.5%
6	2570	1.2%
7	2038	0.9%
8	1718	0.8%
9	1361	0.6%
Other values (146)	10079	4.6%
(Missing)	119258	54.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	41397	19.0%
1	16800	7.7%
2	9333	4.3%
3	6009	2.8%
4	4340	2.0%

Value	Count	Frequency (%)
259	1	< 0.1%
252	1	< 0.1%
251	1	< 0.1%
240	1	< 0.1%
223	1	< 0.1%

nbre_acte_tot
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	907
Distinct (%)	0.9%
Missing	119258
Missing (%)	54.7%
Infinite	0
Infinite (%)	0.0%

Mean	61.49019231
Minimum	1
Maximum	1444
Zeros	0
Zeros (%)	0.0%
Memory size	1.7 MiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	12
median	28
Q3	72
95-th percentile	224
Maximum	1444
Range	1443
Interquartile range (IQR)	60

Descriptive statistics

Standard deviation	95.96342943
Coefficient of variation (CV)	1.560629847
Kurtosis	25.42900746
Mean	61.49019231
Median Absolute Deviation (MAD)	20
Skewness	4.214162516
Sum	6081503
Variance	9208.979788
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9	2621	1.2%
7	2586	1.2%
8	2513	1.2%
6	2510	1.2%
10	2469	1.1%
5	2399	1.1%
11	2258	1.0%
12	2245	1.0%
13	2167	1.0%
4	2154	1.0%
Other values (897)	74980	34.4%
(Missing)	119258	54.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	886	0.4%
2	1411	0.6%
3	1739	0.8%
4	2154	1.0%
5	2399	1.1%

Value	Count	Frequency (%)
1444	1	< 0.1%
1414	1	< 0.1%
1379	1	< 0.1%
1309	1	< 0.1%
1262	1	< 0.1%

nbre_acte_corona_h
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct	79
Distinct (%)	0.5%
Missing	201603
Missing (%)	92.4%
Infinite	0
Infinite (%)	0.0%

Mean	4.771335387
Minimum	0
Maximum	121
Zeros	3358
Zeros (%)	1.5%
Memory size	1.7 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	6
95-th percentile	17
Maximum	121
Range	121
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	7.051266534
Coefficient of variation (CV)	1.477839213
Kurtosis	39.040743
Mean	4.771335387
Median Absolute Deviation (MAD)	2
Skewness	4.663103465
Sum	78999
Variance	49.72035974
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3358	1.5%
1	2519	1.2%
2	2082	1.0%
3	1699	0.8%
4	1355	0.6%
5	1041	0.5%
6	728	0.3%
7	665	0.3%
8	484	0.2%
9	385	0.2%
Other values (69)	2241	1.0%
(Missing)	201603	92.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3358	1.5%
1	2519	1.2%
2	2082	1.0%
3	1699	0.8%
4	1355	0.6%

Value	Count	Frequency (%)
121	1	< 0.1%
114	1	< 0.1%
110	1	< 0.1%
107	1	< 0.1%
103	1	< 0.1%

nbre_acte_corona_f
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct	101
Distinct (%)	0.6%
Missing	201603
Missing (%)	92.4%
Infinite	0
Infinite (%)	0.0%

Mean	6.164643353
Minimum	0
Maximum	144
Zeros	2825
Zeros (%)	1.3%
Memory size	1.7 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	8
95-th percentile	22
Maximum	144
Range	144
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	9.075810152
Coefficient of variation (CV)	1.472236046
Kurtosis	37.312306
Mean	6.164643353
Median Absolute Deviation (MAD)	3
Skewness	4.652615125
Sum	102068
Variance	82.37032992
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2825	1.3%
1	2011	0.9%
2	1827	0.8%
3	1700	0.8%
4	1328	0.6%
5	1086	0.5%
6	848	0.4%
7	725	0.3%
8	578	0.3%
9	465	0.2%
Other values (91)	3164	1.5%
(Missing)	201603	92.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2825	1.3%
1	2011	0.9%
2	1827	0.8%
3	1700	0.8%
4	1328	0.6%

Value	Count	Frequency (%)
144	1	< 0.1%
138	3	< 0.1%
124	1	< 0.1%
122	1	< 0.1%
120	1	< 0.1%

nbre_acte_tot_h
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	441
Distinct (%)	2.7%
Missing	201603
Missing (%)	92.4%
Infinite	0
Infinite (%)	0.0%

Mean	78.14392704
Minimum	0
Maximum	621
Zeros	11
Zeros (%)	< 0.1%
Memory size	1.7 MiB

Quantile statistics

Minimum	0
5-th percentile	15
Q1	36
median	55
Q3	92
95-th percentile	232
Maximum	621
Range	621
Interquartile range (IQR)	56

Descriptive statistics

Standard deviation	70.51416285
Coefficient of variation (CV)	0.9023626726
Kurtosis	6.358756292
Mean	78.14392704
Median Absolute Deviation (MAD)	24
Skewness	2.2748564
Sum	1293829
Variance	4972.247162
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
39	270	0.1%
43	264	0.1%
40	260	0.1%
36	246	0.1%
44	241	0.1%
38	232	0.1%
37	230	0.1%
45	229	0.1%
35	229	0.1%
41	228	0.1%
Other values (431)	14128	6.5%
(Missing)	201603	92.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	11	< 0.1%
1	7	< 0.1%
2	24	< 0.1%
3	23	< 0.1%
4	26	< 0.1%

Value	Count	Frequency (%)
621	1	< 0.1%
620	1	< 0.1%
565	1	< 0.1%
555	1	< 0.1%
552	2	< 0.1%

nbre_acte_tot_f
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	562
Distinct (%)	3.4%
Missing	201603
Missing (%)	92.4%
Infinite	0
Infinite (%)	0.0%

Mean	105.6936039
Minimum	0
Maximum	824
Zeros	1
Zeros (%)	< 0.1%
Memory size	1.7 MiB

Quantile statistics

Minimum	0
5-th percentile	21
Q1	50
median	75
Q3	125
95-th percentile	312
Maximum	824
Range	824
Interquartile range (IQR)	75

Descriptive statistics

Standard deviation	93.136463
Coefficient of variation (CV)	0.8811929914
Kurtosis	6.381608919
Mean	105.6936039
Median Absolute Deviation (MAD)	32
Skewness	2.286216951
Sum	1749969
Variance	8674.40074
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
63	198	0.1%
58	195	0.1%
52	193	0.1%
66	191	0.1%
49	191	0.1%
61	191	0.1%
59	189	0.1%
64	189	0.1%
51	189	0.1%
68	186	0.1%
Other values (552)	14645	6.7%
(Missing)	201603	92.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	5	< 0.1%
2	5	< 0.1%
3	10	< 0.1%
4	6	< 0.1%

Value	Count	Frequency (%)
824	1	< 0.1%
823	1	< 0.1%
793	1	< 0.1%
742	1	< 0.1%
707	1	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	dep	date_de_passage	sursaud_cl_age_corona	nbre_pass_tot	nbre_pass_corona_h	nbre_pass_corona_f	nbre_pass_tot_h	nbre_pass_tot_f	nbre_hospit_corona_h	nbre_hospit_corona_f	nbre_acte_corona	nbre_acte_tot	nbre_acte_corona_h	nbre_acte_corona_f	nbre_acte_tot_h	nbre_acte_tot_f
0	01	2020-02-24	0	357.0	0.0	0.0	202.0	155.0	0.0	0.0	NaN	NaN	NaN	NaN	NaN	NaN
1	01	2020-02-24	A	73.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
2	01	2020-02-24	B	155.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
3	01	2020-02-24	C	61.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
4	01	2020-02-24	D	28.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
5	01	2020-02-24	E	40.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
6	01	2020-02-25	0	310.0	0.0	0.0	177.0	133.0	0.0	0.0	NaN	NaN	NaN	NaN	NaN	NaN
7	01	2020-02-25	A	70.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
8	01	2020-02-25	B	117.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
9	01	2020-02-25	C	53.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN

Last rows

	dep	date_de_passage	sursaud_cl_age_corona	nbre_pass_corona	nbre_pass_tot	nbre_hospit_corona	nbre_pass_corona_h	nbre_pass_corona_f	nbre_pass_tot_h	nbre_pass_tot_f	nbre_hospit_corona_h	nbre_hospit_corona_f	nbre_acte_corona	nbre_acte_tot	nbre_acte_corona_h	nbre_acte_corona_f	nbre_acte_tot_h	nbre_acte_tot_f
218150	976	2021-02-16	B	10.0	44.0	2.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
218151	976	2021-02-16	C	6.0	15.0	2.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
218152	976	2021-02-16	D	3.0	4.0	3.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
218153	976	2021-02-16	E	4.0	4.0	2.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
218154	976	2021-02-17	0	8.0	64.0	1.0	4.0	4.0	36.0	28.0	0.0	1.0	NaN	NaN	NaN	NaN	NaN	NaN
218155	976	2021-02-17	A	0.0	21.0	0.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
218156	976	2021-02-17	B	3.0	28.0	1.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
218157	976	2021-02-17	C	3.0	11.0	0.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
218158	976	2021-02-17	D	2.0	3.0	0.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
218159	976	2021-02-17	E	0.0	1.0	0.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows